package eu.vranckaert.workRegistrationWidget.dao.util;

public final class DatabaseVars {
    public static final String DATABASE_NAME = "TimeRegistration";
    public static final int DATABASE_VERSION = 3;
    public static final String TABLE_CAT = "categories";
    public static final String CAT_FIELDS_ID = "id";
    public static final String CAT_FIELDS_NAME = "name";
    public static final String TABLE_TIMEREG = "timereg";
    public static final String TIMEREG_FIELDS_ID = "id";
    public static final String TIMEREG_FIELDS_STARTDATE = "startdate";
    public static final String TIMEREG_FIELDS_ENDDATE = "enddate";
    public static final String TIMEREG_FIELDS_STARTLATITUDE = "startLatitude";
    public static final String TIMEREG_FIELDS_STARTLONGTITUDE = "startLongtitude";
    public static final String TIMEREG_FIELDS_ENDLATITUDE = "endLatitude";
    public static final String TIMEREG_FIELDS_ENDLONGTITUDE = "endLongtitude";
    public static final String TIMEREG_FIELDS_CATID = "catid";
    public static final String STMT_CREATE_CAT = "create table categories (id integer primary key autoincrement, name text not null);";
    public static final String STMT_CREATE_TIMEREG = "create table timereg (id integer primary key autoincrement, startdate integer not null, enddate integer null, startlocx varchar null, startlocy varchar null, endlocx varchar null, endlocy varchar null, catid integer null);";

    public static final String DESC = "DESC";
    public static final String ASC = "ASC";
}
